Stored Procedures [dbo].[BAEImisNameGetAddressNumAndPurposeForUser]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Idvarchar(10)10
SQL Script
CREATE PROCEDURE [dbo].[BAEImisNameGetAddressNumAndPurposeForUser]
@Id varchar(10) AS
SELECT ADDRESS_NUM, PURPOSE
    FROM Name_Address
    WHERE ID = @Id

GO
Uses